To set Null value for the cell, control-click the selected cell and select Set NULL.
To edit the text field record, just simply enables Show Text In Grid under the Edit menu.
Hint: To view/edit the text field record in an ease way, see Memo Editor.
To view images in the grid, just simply enables Show Image In Grid under the Edit menu.
Hint: To view/edit the image in an ease way, see Image Editor.
To edit a Date/Time record, just simply click to open the editor for editing.
Note: Available only for MySQL, Oracle, PostgreSQL and SQL Server.
- Choose/enter the desired data. The editor used in cell is determined by
the field type assigned to the column.
DateTimeDateTime / Timestamp
To edit a Enum record, just simply choose the record from the drop-down list.
Note: Available only for MySQL.
To edit a Set record, just simply click to open the editor for editing.
Note: Available only for MySQL.
- Select the record(s) from the list. To remove the records, uncheck them in the same way.
To view BFile content, just simply enables Preview BFILE under the Edit menu. (see also Text/Blob/BFile View)
Note: Available only for Oracle.
To generate UUID/GUID, control-click the selected cell and select Generate UUID.
Note: Available only for PostgreSQL and SQL Server.